import pymysql
conn = pymysql.connect(host='120.78.6.253',port=3306,user='root',password='123456',db='bbs',charset='utf8')
cursor=conn.cursor(pymysql.cursors.DictCursor)
sql = 'select username,usertype,password,regtime,email from user1'
cursor.execute(sql,)
select = cursor.fetchall()
print(select)
cursor.close()